package com.supcon.exchangedata.repository.master;


import com.supcon.exchangedata.pojo.entity.oracle.HjOrganized;
import org.springframework.data.jpa.repository.JpaRepository;
import org.springframework.data.jpa.repository.Query;
import org.springframework.transaction.annotation.Transactional;

public interface MasterHjOrganizedRepository  extends JpaRepository<HjOrganized, String> {
    /**
     * 根据id查询是否存在相同的数据
     */
    @Transactional
    @Query(nativeQuery = true, value = "SELECT ID FROM HJ_CLEAN_ORGANIZED WHERE 'DAY' = ?1 and ADDRESS = ?2")
    HjOrganized getById(String day , String address);
}
